---------------- chi tiet lai suat --------------
----------- xem chi tiet lai suat------------
if exists (select name from sysobjects where name like 'Proc_ChiTietLaiSuat_GetById')
	drop procedure Proc_ChiTietLaiSuat_GetById
go

create PROC Proc_ChiTietLaiSuat_GetById (@maChiTietLS int )
as
	select * from ChiTietLaiSuat
	where MaChiTietLS = @maChiTietLS
go

Exec Proc_ChiTietLaiSuat_GetById 1
go

--------------------------------------------
---------- xem thong tin lai suat qua ki han lai suat---------------
if exists (select name from sysobjects where name like 'Proc_ChiTietLaiSuat_GetByMaLoaiKH')
	drop procedure Proc_ChiTietLaiSuat_GetByMaLoaiKH
go

create PROC Proc_ChiTietLaiSuat_GetByMaLoaiKH (@maLoaiKH int )
as
	select * from ChiTietLaiSuat
	where MaLoaiKHLS = @maLoaiKH
go

Exec Proc_ChiTietLaiSuat_GetByMaLoaiKH 1
go

----------------------------------------------------------------
------------- xem thong tin lai suat thong qua ma ngay van dung ------------------
if exists (select name from sysobjects where name like 'Proc_ChiTietLaiSuat_GetByMaNgayVDLS')
	drop procedure Proc_ChiTietLaiSuat_GetByMaNgayVDLS
go

create PROC Proc_ChiTietLaiSuat_GetByMaNgayVDLS(@maNgayVDLS int )
as
	select * from ChiTietLaiSuat
	where MaNgayVDLS = @maNgayVDLS
go

Exec Proc_ChiTietLaiSuat_GetByMaNgayVDLS 1
go

---------------------------------------------------------------
------------- xem thong tin chi tiet lai suat  thong qua loai tien---------------
if exists (select name from sysobjects where name like 'Proc_ChiTietLaiSuat_GetByMaLoaiTien')
	drop procedure Proc_ChiTietLaiSuat_GetByMaLoaiTien
go

create PROC Proc_ChiTietLaiSuat_GetByMaLoaiTien(@maLoaiTien int )
as
	select * from ChiTietLaiSuat
	where LoaiTien = @maLoaiTien
go

Exec Proc_ChiTietLaiSuat_GetByMaLoaiTien 1
go
